{"text_format":"3","workbook":"xls","n_sheets":5,"sheets":["Version I","Version II","Split Production","INSTRUCTIONS","INSTRUCTIONS OLD"],"not_rendered":{"macros":1,"external_links":1,"defined_names":33,"comments":49},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Version I","index":0,"n_rows":174,"n_cols":50,"rows_kept":174,"merged":[[2,1,2,17],[4,3,4,4],[4,7,4,8],[4,9,4,13],[4,14,4,18],[5,1,5,2],[5,3,5,7],[5,9,5,11],[5,12,5,13],[5,14,5,16],[6,14,6,16],[7,1,7,2],[7,14,7,16],[8,1,8,2],[8,14,8,16],[9,1,9,2],[9,14,9,16],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,3,14,4],[14,6,14,7],[14,9,14,10],[16,17,16,18],[17,17,17,18],[18,17,18,18],[19,17,19,18],[20,17,20,18],[21,17,21,18],[22,17,22,18],[23,17,23,18],[24,17,24,18],[25,17,25,18],[26,17,26,18],[27,17,27,18],[28,17,28,18],[29,17,29,18],[30,17,30,18],[31,17,31,18],[32,17,32,18],[33,17,33,18],[34,17,34,18],[35,17,35,18],[36,17,36,18],[37,17,37,18],[38,17,38,18],[39,17,39,18],[40,17,40,18],[41,17,41,18],[42,1,42,2],[42,3,42,4],[42,5,42,6],[42,8,42,10],[42,11,42,13],[42,16,42,18],[43,1,43,2],[43,3,43,4],[43,5,43,6],[43,9,43,10],[43,12,43,13],[43,17,43,18],[44,14,44,18],[45,2,46,10],[45,12,45,13],[45,16,45,17],[46,12,46,13],[46,16,46,17],[49,8,49,9],[65,1,65,2]],"flags":["formulas_cached_only"]}
[null,"REVISED","2005-08-11"]
[{"$nulls":9},"SPEC. YEAR  \"2005\""]
[null,"DENSITY  INCENTIVE / DISINCENTIVE  WORKSHEET  ",{"$nulls":18},"tons/sq yd"]
[]
[null,null,"S.P.",null,null,"HWY",null,"LOCATION",{"$nulls":6},"",{"$nulls":5},{"v":0.086,"d":"8.60%"},null,null,0]
[null,"CONTRACTOR",{"$nulls":7},"GYRATORY DESIGN",null,null,"",null,"",null,null,4300,null,null,"total tons"]
[{"$nulls":12},"PAVED",null,"MAT THICKNESS =",{"$nulls":5},50000]
[null,"SAMPLE NUMBER",null,301,302,303,304,305,306,307,308,309,"CORED",null,"TOTAL TONS PAVED =",null,null,50000,null,null,"max density tons"]
[null,"SAMPLE TON #",null,300,1000,1800,2300,2700,3100,3500,4000,4100,"BID PRICE=",{"v":2.5,"d":"$2.50"},"MAX. DENSITY TONS =",null,null,45000,null,null,45000]
[null,"TONS REPRESENTED",null,1000,800,500,400,400,400,500,100,45900,"MIX  TYPE  ","SPWER","INCENT/DISINC RATIO=",null,null,{"v":0.9,"d":"0.90"},null,null,"tons per lot",{"$nulls":5},1.22312]
[null,"DENSITY TONS",null,900,720,450,360,360,360,450,90,41310,"Gmm.=",2.783,null,null,"OVERRIDE # LOTS = ",{"$nulls":3},7500,{"$nulls":5},1.223,{"$nulls":9},""]
[null,"INDIVIDUAL VOIDS",null,3.8,3.7,4.1,3.7,{"v":4,"d":"4.0"},{"v":4,"d":"4.0"},{"v":5,"d":"5.0"},4.4,{"v":4,"d":"4.0"},"TON TYPE ","ENGLISH","           LOTS REQUIRED =",null,null,6,null,null,"Adjusted Price per ton"]
[null,"IND. MAX SP.G.",null,{"v":3,"d":"3.000"},{"v":2.65,"d":"2.650"},{"v":2.7,"d":"2.700"}]
[null,"MOVNG AVG SP.G.",null,{"v":2.5,"d":"2.500"},{"v":2.5,"d":"2.500"},{"v":2.45,"d":"2.450"}]
[{"$nulls":3},"   DESIGN AIR VOIDS =",null,{"v":4,"d":"4.0"},"         MIN. AIR VOIDS =",null,3.5,"          REQ'D DENSITY=",null,{"v":91,"d":"91.0"},null,null,"            TONS PER LOT =",null,null,{"v":7500,"d":"7500.00"},null,null,{"v":2.5,"d":"2.50"}]
[{"$nulls":14},"",null,null,""]
[null,null,"CORE",null,"CORE/PAN",{"$nulls":4},"% WATER","Gmb /","BULK ","%","AIR VOID","TONS","Sq Yd","PAY","INCENTIVE"]
["LOT","CORE #","THICKNESS","AIR DRY","(or dry wt.)","PAN WT.","DRY WT.","SSD WT.","IMM WT.","ABSORBED","BULK SP.G","SpG. USED","DENSITY","USED","REPRESENT.","REPRESENT","FACTOR","DISINCENTIVE"]
[22,22.1,{"v":2,"d":"2.00"},533.3,543.1,10.3,{"v":532.8000000000001,"d":"532.8"},533.6,{"v":290,"d":"290.0"},{"v":0.1231527093596339,"d":"0.1"},2.187,2.187,74.3,{"v":4,"d":"4.0"},{"v":899.99,"d":"900"},"",{"$error":"#N/A"},{"$error":"#N/A"}]
[null,22.2,{"v":2.2,"d":"2.20"},{"v":657,"d":"657.0"},666.8,10.1,{"v":656.6999999999999,"d":"656.7"},657.2,{"v":320,"d":"320.0"},{"v":0.05931198102017955,"d":"0.1"},1.948,1.948,null,{"v":4,"d":"4.0"},720,"",{"$error":"#N/A"},{"$error":"#N/A"},null,null,0]
["COMP",null,{"v":2,"d":"2.00"},739.5,749.2,10.1,739.1,740.2,{"v":400,"d":"400.0"},{"v":0.2057613168724413,"d":"0.2"},""," ",null,{"v":4,"d":"4.0"},810,"",{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"v":2.066666666666667,"d":"2.07"},"= AVERAGE CORE THICKNESS",{"$nulls":7},2.068,"= Ave.Gmb.",{"v":4,"d":"4.0"},5070,"",{"$error":"#N/A"},{"$error":"#N/A"}]
[23,23.1,{"$nulls":4},{"v":0,"d":"0.0"},null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,23.2,{"$nulls":4},{"v":0,"d":"0.0"},null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["COMP",{"$nulls":5},{"v":0,"d":"0.0"},null,null,"",""," ",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,"","",{"$nulls":7},{"$error":"#VALUE!"},"= Ave.Gmb.",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[24,24.1,{"$nulls":4},{"v":0,"d":"0.0"},null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,24.2,{"$nulls":4},{"v":0,"d":"0.0"},null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["COMP",{"$nulls":5},{"v":0,"d":"0.0"},null,null,"",""," ",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,"","",{"$nulls":7},{"$error":"#VALUE!"},"= Ave.Gmb.",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[25,25.1,{"$nulls":4},{"v":0,"d":"0.0"},null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,25.2,{"$nulls":4},{"v":0,"d":"0.0"},null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["COMP",{"$nulls":5},{"v":0,"d":"0.0"},null,null,"",""," ",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,"","",{"$nulls":7},{"$error":"#VALUE!"},"= Ave.Gmb.",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[26,26.1,{"$nulls":4},{"v":0,"d":"0.0"},null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,26.2,{"$nulls":4},{"v":0,"d":"0.0"},null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["COMP",{"$nulls":5},{"v":0,"d":"0.0"},null,null,"",""," ",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,"","",{"$nulls":7},{"$error":"#VALUE!"},"= Ave.Gmb.",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[27,27.1,{"$nulls":4},{"v":0,"d":"0.0"},null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,27.2,{"$nulls":4},{"v":0,"d":"0.0"},null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["COMP",{"$nulls":5},{"v":0,"d":"0.0"},null,null,"",""," ",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,"","",{"$nulls":7},{"$error":"#VALUE!"},"= Ave.Gmb.",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"v":4,"d":"4.0"},"DATA  BY :",{"$nulls":3},"      Average Density =",null,{"$error":"#VALUE!"},"INCENTIVE THIS SHEET",null,null,"DISINCENTIVE THIS SHEET",{"$nulls":4},"INCENTIVE / DISINCENTIVE"]
[null,"MIX DESIGNATION :",{"$nulls":3},"lbs.per square yd in.=",null,{"$error":"#VALUE!"}," TOTAL =",{"$error":"#N/A"},null," TOTAL =",{"$error":"#N/A"},{"$nulls":3},"NET Total =",{"$error":"#N/A"}]
[null,"NOTES",{"$nulls":12},"Weighted Average Air Voids"]
[{"$nulls":11},"CHK'D BY",null,null,"DATE :"]
[{"$nulls":11},"PLANT # :",null,null,"MDR.# :"]
[]
[]
[]
[{"$nulls":5},"Would you like to calculate and use the weighted average"]
[{"$nulls":5},"of the production air voids, rather than using the individual "]
[{"$nulls":5},"air voids?  The incentive/disincentive calculated using this"]
[{"$nulls":5},"option is to be used for information only.  The specification "]
[{"$nulls":5},"calls for using the individual air voids and the weighted average",{"$nulls":15},"yes"]
[{"$nulls":5},"method should NOT be used to calculate the actual ",{"$nulls":15},"no"]
[{"$nulls":5},"incentive/disincentive to be paid to the contractor."]
[{"$nulls":21},2350,2350,2350,2360,2360,2360]
[{"$nulls":5},"I would like to use the weighted average of the air voids - ",{"$nulls":5},"yes",{"$nulls":8},"%DENS.",-1,2,"RED. (3)","upper 4\" (4)","lower 4\"(5)",6]
[{"$nulls":21},"hv","MV LV"," MV LV",">4\" REDUCED",null,"up 4\" red.",null,null,"MIN.VOID","REQ. DENS.","DEN.COL.","INCENT*","VOID LIMIT"]
[{"$nulls":6},"air void weighted average = ",null,null,{"v":4,"d":"4.0"},{"$nulls":12},"SP WEAR,SHLD","SP WEAR,SHLD",{"$nulls":4},"LV",2.5,{"v":92,"d":"92.0"},2,2,1]
[{"$nulls":20},87,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"LVR",2.5,{"v":91,"d":"91.0"},3,2,1,{"$nulls":10},"TONS PAVED (metric) =",null,45000,null,{"v":0,"d":"0.0"},{"v":3.8,"d":"3.80"}]
[{"$nulls":20},87.1,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"MV",{"v":3,"d":"3.0"},{"v":92,"d":"92.0"},2,2,2,{"$nulls":10},"     LOTS tested =",null,6,null,{"v":900,"d":"900.0"},{"v":3.7,"d":"3.70"}]
[{"$nulls":20},87.2,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"MVR",{"v":3,"d":"3.0"},{"v":91,"d":"91.0"},3,2,2,{"$nulls":10},"        TONS PER LOT=",null,{"v":7500,"d":"7500.00"},null,{"v":1620,"d":"1620.0"},{"v":4.1,"d":"4.10"}]
["max",null,"a",1,2,3,4,5,6,7,8,9,{"$nulls":8},87.3,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"SPNW",2.5,{"v":93,"d":"93.0"},5,2,1,"NONWEAR",1,{"$nulls":10},3.5,null,{"v":2070,"d":"2070.0"},{"v":3.7,"d":"3.70"}]
["average","average mx spg",null,{"v":3,"d":"3.000"},2.825,2.783,2.088,{"v":1.67,"d":"1.670"},1.392,1.193,1.044,0.928,{"$nulls":8},87.4,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"SPNWR",2.5,{"v":92,"d":"92.0"},6,1,1,"NW",1,{"$nulls":6},"",null,{"v":2.5,"d":"$2.50"},null,{"v":91,"d":"91.0"},null,{"v":2430,"d":"2430.0"},{"v":4,"d":"4.00"}]
[null,"is average available",null,1,1,1,0,0,0,0,0,0,{"$nulls":8},87.5,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"SPSHLD3",2.5,93,5,2,1,"WEAR",2,{"$nulls":12},{"v":2790,"d":"2790.0"},{"v":4,"d":"4.00"}]
[null,"number of max's",null,3,{"$nulls":16},87.6,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"SPSHLD3R",2.5,92,6,1,1,{"$nulls":14},{"v":3150,"d":"3150.0"},{"v":5,"d":"5.00"}]
[{"$nulls":20},87.7,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"SPSHLD4",3.5,92,2,2,3,{"$nulls":14},{"v":3600,"d":"3600.0"},{"v":4.4,"d":"4.40"}]
[null,"look up the avg",null,2.783,{"$nulls":16},87.8,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"SPSHLD4R",3.5,91,3,2,2,"VOID LIMIT",3,"Q/C","SAMPLE #",1,2,3,4,5,6,7,8,9,null,{"v":3690,"d":"3690.0"},{"v":4,"d":"4.00"}]
[{"$nulls":20},87.9,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"SPWE",3.5,{"v":92,"d":"92.0"},2,2,3,"DENSITY",3,"SAMPLES","TON #",300,1000,1800,2300,2700,3100,3500,4000,4100,null,45000.1]
[{"$nulls":3},1,2,3,4,5,6,7,8,9,{"$nulls":8},88,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"SPWER",3.5,{"v":91,"d":"91.0"},3,2,3,"INCENT.",2,null,"TONS REP.",1000,800,500,400,400,400,500,100,45900]
[{"$nulls":3},{"v":2.5,"d":"2.500"},{"v":2.5,"d":"2.500"},{"v":2.45,"d":"2.450"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"$nulls":8},88.1,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",{"$nulls":3},"INCENT* - 1 = N0, 2 = YES",{"$nulls":6},"MAX TONS",900,720,450,360,360,360,450,90,41310]
[{"$nulls":3},1,1,1,0,0,0,0,0,0,{"$nulls":8},88.2,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",{"$nulls":3},"VOID LIMIT - 3 = 3.5%MIN, 2 = 3%MIN, 1 = 2.5%MIN.",{"$nulls":6},"AIR VOIDS",{"v":3.8,"d":"3.80"},{"v":3.7,"d":"3.70"},{"v":4.1,"d":"4.10"},{"v":3.7,"d":"3.70"},{"v":4,"d":"4.00"},{"v":4,"d":"4.00"},{"v":5,"d":"5.00"},{"v":4.4,"d":"4.40"},{"v":4,"d":"4.00"}]
[{"$nulls":3},3,{"$nulls":16},88.3,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"ENGLISH",{"$nulls":20},{"v":45000,"d":"45000.0"}]
[{"$nulls":3},{"v":2.45,"d":"2.450"},{"$nulls":16},88.4,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"METRIC",{"$nulls":4},"LOT #",{"$nulls":6},"PRICE  ADJ.","DENSITY","AIR VOID","TONS","FACTOR","in/dis",{"$nulls":3},{"v":45000,"d":"45000.0"}]
[{"$nulls":20},88.5,-0.3,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",{"$nulls":6},1,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#VALUE!"},{"$error":"#N/A"},74.3,{"v":4,"d":"4.00"},{"v":899.99,"d":"900.0"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":899.99,"d":"900.0"}]
[{"$nulls":20},88.6,-0.3,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",{"$nulls":7},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#VALUE!"},{"$error":"#N/A"},null,{"v":4,"d":"4.00"},{"v":720,"d":"720.0"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":1619.99,"d":"1620.0"}]
[{"$nulls":20},88.7,-0.3,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"english",2,null,"ton type",null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,{"v":4,"d":"4.00"},{"v":810,"d":"810.0"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":2429.99,"d":"2430.0"}]
[{"$nulls":20},88.8,-0.3,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"metric",1,null,2,{"$nulls":8},{"$error":"#N/A"},null,{"v":4,"d":"4.00"},{"v":5070,"d":"5070.0"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":7499.99,"d":"7500.0"}]
[{"$nulls":20},88.9,-0.3,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",{"$nulls":6},2,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"v":4,"d":"4.00"},{"v":7499.99,"d":"7500.0"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"v":14999.98,"d":"15000.0"}]
[{"$nulls":20},{"v":89,"d":"89.0"},-0.15,-0.3,-0.3,{"v":-0.3,"d":"-0.30"},"SEE SPEC.",-0.3,{"$nulls":7},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"v":14999.98,"d":"15000.0"}]
[{"$nulls":20},89.1,-0.15,-0.3,-0.3,{"v":-0.3,"d":"-0.30"},"SEE SPEC.",-0.3,null,"Tons","Lots","ENGLISH",{"$nulls":3},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"},null,"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"v":14999.98,"d":"15000.0"}]
[{"$nulls":20},89.2,-0.15,-0.3,-0.15,{"v":-0.3,"d":"-0.30"},"SEE SPEC.",-0.3,null,0.1,0,0.1,0,{"$nulls":8},{"$error":"#VALUE!"},null,"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"v":14999.98,"d":"15000.0"}]
[{"$nulls":20},89.3,-0.15,-0.3,-0.15,{"v":-0.3,"d":"-0.30"},"SEE SPEC.",-0.3,null,1,1,1,1,null,3,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"v":4,"d":"4.00"},{"v":7499.99,"d":"7500.0"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"v":22499.97,"d":"22500.0"}]
[{"$nulls":20},89.4,-0.15,-0.3,-0.09,{"v":-0.3,"d":"-0.30"},"SEE SPEC.",-0.3,null,546,2,601,2,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"v":22499.97,"d":"22500.0"}]
[{"$nulls":20},89.5,-0.09,-0.15,-0.09,-0.15,"SEE SPEC.",-0.15,null,911,3,1001,3,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"},null,"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"v":22499.97,"d":"22500.0"}]
[{"$nulls":20},89.6,-0.09,-0.15,-0.09,-0.15,"SEE SPEC.",-0.15,null,1456,4,1601,4,{"$nulls":8},{"$error":"#VALUE!"},null,"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"v":22499.97,"d":"22500.0"}]
[{"$nulls":20},89.7,-0.09,-0.15,-0.05,-0.15,"SEE SPEC.",-0.15,null,3276,5,3601,5,null,4,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"v":4,"d":"4.00"},{"v":7499.990000000002,"d":"7500.0"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"v":29999.960000000003,"d":"30000.0"}]
[{"$nulls":20},89.8,-0.09,-0.15,-0.05,-0.15,"SEE SPEC.",-0.15,null,4546,6,5001,6,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"v":29999.960000000003,"d":"30000.0"}]
[{"$nulls":20},89.9,-0.09,-0.15,-0.05,-0.15,"SEE SPEC.",-0.15,null,9999,6,9999,6,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"},null,"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"v":29999.960000000003,"d":"30000.0"}]
[{"$nulls":20},90,-0.05,-0.09,-0.02,-0.09,{"v":-0.3,"d":"-0.30"},-0.09,{"$nulls":13},{"$error":"#VALUE!"},null,"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"v":29999.960000000003,"d":"30000.0"}]
[{"$nulls":20},90.1,-0.05,-0.09,-0.02,-0.09,{"v":-0.3,"d":"-0.30"},-0.09,{"$nulls":6},5,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"v":4,"d":"4.00"},{"v":7499.990000000002,"d":"7500.0"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"v":37499.950000000004,"d":"37500.0"}]
[{"$nulls":20},90.2,-0.05,-0.09,-0.02,-0.09,{"v":-0.3,"d":"-0.30"},-0.09,{"$nulls":7},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"v":37499.950000000004,"d":"37500.0"}]
[{"$nulls":20},90.3,-0.05,-0.09,-0.02,-0.09,{"v":-0.3,"d":"-0.30"},-0.09,{"$nulls":7},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"},null,"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"v":37499.950000000004,"d":"37500.0"}]
[{"$nulls":20},90.4,-0.05,-0.09,-0.02,-0.09,{"v":-0.3,"d":"-0.30"},-0.09,{"$nulls":13},{"$error":"#VALUE!"},null,"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"v":37499.950000000004,"d":"37500.0"}]
[{"$nulls":20},90.5,-0.02,-0.05,-0.02,-0.05,-0.15,-0.05,{"$nulls":6},6,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"v":4,"d":"4.00"},{"v":7499.989999999998,"d":"7500.0"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"v":44999.94,"d":"44999.9"}]
[{"$nulls":20},90.6,-0.02,-0.05,-0.02,-0.05,-0.15,-0.05,{"$nulls":7},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"v":44999.94,"d":"44999.9"}]
[{"$nulls":20},90.7,-0.02,-0.05,-0.02,-0.05,-0.15,-0.05,{"$nulls":7},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"},null,"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"v":44999.94,"d":"44999.9"}]
[{"$nulls":20},90.8,-0.02,-0.05,-0.02,-0.05,-0.15,-0.05,{"$nulls":13},{"$error":"#VALUE!"},null,"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"v":44999.94,"d":"44999.9"}]
[{"$nulls":20},90.9,-0.02,-0.05,-0.02,-0.05,-0.15,-0.05]
[{"$nulls":20},91,-0.02,-0.02,0,-0.02,-0.09,-0.02]
[{"$nulls":20},91.1,-0.02,-0.02,0,-0.02,-0.09,-0.02]
[{"$nulls":20},91.2,-0.02,-0.02,0,-0.02,-0.09,-0.02,null,"SAMPLE ","LOT 1","LOT 2","LOT 3","LOT 4","LOT 5","LOT 6",null,"S.P."]
[{"$nulls":20},91.3,-0.02,-0.02,0,-0.02,-0.09,-0.02,null,"TON",{"$nulls":7},"S.A.P"]
[{"$nulls":20},91.4,-0.02,-0.02,0,-0.02,-0.09,-0.02,null,"samples",{"v":7500,"d":"7500.00"},{"v":15000,"d":"15000.00"},{"v":22500,"d":"22500.00"},{"v":30000,"d":"30000.00"},{"v":37500,"d":"37500.00"},{"v":45000,"d":"45000.00"},null,"C.P."]
[{"$nulls":20},91.5,0,-0.02,0,-0.02,-0.05,-0.02,null,{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},"","","","","",null,6]
[{"$nulls":20},91.6,0,-0.02,0,-0.02,-0.05,-0.02,null,{"v":1620,"d":"1620.00"},{"v":1620,"d":"1620.00"},"","","","","",null,"LV","MARSHALL DESIGN"]
[{"$nulls":20},91.7,0,-0.02,0,-0.02,-0.05,-0.02,null,{"v":2070,"d":"2070.00"},{"v":2070,"d":"2070.00"},"","","","","",null,"LVR","MARSHALL DESIGN"]
[{"$nulls":20},91.8,0,-0.02,0,-0.02,-0.05,-0.02,null,{"v":2430,"d":"2430.00"},{"v":2430,"d":"2430.00"},"","","","","",null,"MV","MARSHALL DESIGN"]
[{"$nulls":20},91.9,0,-0.02,0,-0.02,-0.05,-0.02,null,{"v":2790,"d":"2790.00"},"","","","","","",null,"MVR","MARSHALL DESIGN"]
[{"$nulls":20},92,0,0,0,{"v":0,"d":"0.00"},-0.02,0,null,{"v":3150,"d":"3150.00"},"","","","","","",null,"SPNW","GYRATORY DESIGN"]
[{"$nulls":20},92.1,0,0,0,{"v":0,"d":"0.00"},-0.02,0,null,{"v":3600,"d":"3600.00"},"","","","","","",null,"SPNWR","GYRATORY DESIGN"]
[{"$nulls":20},92.2,0,0,0,{"v":0,"d":"0.00"},-0.02,0,null,{"v":3690,"d":"3690.00"},"","","","","","",null,"SPSHLD3","GYRATORY DESIGN"]
[{"$nulls":20},92.3,0,0,0,{"v":0,"d":"0.00"},-0.02,0,null,null,0.01,7500.01,15000.01,22500.01,30000.01,37500.01,null,"SPSHLD4","GYRATORY DESIGN"]
[{"$nulls":20},92.4,0,0,0,{"v":0,"d":"0.00"},-0.02,0,null,null,{"v":900,"d":"900.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,"SPSHLD3R","GYRATORY DESIGN"]
[{"$nulls":20},92.5,0,0,0,{"v":0,"d":"0.00"},-0.02,0,null,null,{"v":1620,"d":"1620.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,"SPSHLD4R","GYRATORY DESIGN"]
[{"$nulls":20},92.6,0.02,0,0,{"v":0,"d":"0.00"},-0.02,0,null,null,{"v":2430,"d":"2430.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,"SPWE","GYRATORY DESIGN"]
[{"$nulls":20},92.7,0.02,0,0,{"v":0,"d":"0.00"},-0.02,0,null,null,{"v":7500,"d":"7500.00"},{"v":15000,"d":"15000.00"},{"v":22500,"d":"22500.00"},{"v":30000,"d":"30000.00"},{"v":37500,"d":"37500.00"},{"v":45000,"d":"45000.00"},null,"SPWER","GYRATORY DESIGN"]
[{"$nulls":20},92.8,0.02,0,0,{"v":0,"d":"0.00"},-0.02,0,null,null,0.01,7500.01,15000.01,22500.01,30000.01,37500.01,null,1,{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":20},92.9,0.02,0,0,{"v":0,"d":"0.00"},-0.02,0,null,null,{"v":900,"d":"900.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":20},93,0.02,0,0,{"v":0,"d":"0.00"},0,0,null,null,{"v":1620,"d":"1620.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":20},93.1,0.04,0.02,0,0.02,0,0,null,null,{"v":2430,"d":"2430.00"},{"v":15000,"d":"15000.00"},{"v":22500,"d":"22500.00"},{"v":30000,"d":"30000.00"},{"v":37500,"d":"37500.00"},{"v":45000,"d":"45000.00"},null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":20},93.2,0.04,0.02,0,0.02,0,0,null,null,7500,"","","","","",null,2,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":20},93.3,0.04,0.02,0,0.02,0,0,null,null,0.01,7500.01,15000.01,22500.01,30000.01,37500.01,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":20},93.4,0.04,0.02,0,0.02,0,0,null,null,{"v":900,"d":"900.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":20},93.5,0.04,0.02,0,0.02,0,0,null,null,{"v":1620,"d":"1620.00"},{"v":15000,"d":"15000.00"},{"v":22500,"d":"22500.00"},{"v":30000,"d":"30000.00"},{"v":37500,"d":"37500.00"},{"v":45000,"d":"45000.00"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":20},93.6,0.04,0.04,0,0.04,0,0,null,null,{"v":2430,"d":"2430.00"},{"v":15000,"d":"15000.00"},{"v":22500,"d":"22500.00"},{"v":30000,"d":"30000.00"},{"v":37500,"d":"37500.00"},{"v":45000,"d":"45000.00"},null,3,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":20},93.7,0.04,0.04,0,0.04,0,0,null,null,{"v":7500,"d":"7500.00"},"","","","","",null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":20},93.8,0.04,0.04,0,0.04,0,0,null,null,0.01,7500.01,15000.01,22500.01,30000.01,37500.01,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":20},93.9,0.04,0.04,0,0.04,0,0,null,null,{"v":900,"d":"900.00"},{"v":15000,"d":"15000.00"},{"v":22500,"d":"22500.00"},{"v":30000,"d":"30000.00"},{"v":37500,"d":"37500.00"},{"v":45000,"d":"45000.00"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":20},{"v":94,"d":"94.0"},0.04,0.04,0,0.04,0,0,null,null,{"v":1620,"d":"1620.00"},{"v":15000,"d":"15000.00"},{"v":22500,"d":"22500.00"},{"v":30000,"d":"30000.00"},{"v":37500,"d":"37500.00"},{"v":45000,"d":"45000.00"},null,4,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":20},94.1,0.04,0.04,0,0.04,0.02,0,null,null,{"v":2430,"d":"2430.00"},{"v":15000,"d":"15000.00"},{"v":22500,"d":"22500.00"},{"v":30000,"d":"30000.00"},{"v":37500,"d":"37500.00"},{"v":45000,"d":"45000.00"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":20},94.2,0.04,0.04,0,0.04,0.02,0,null,null,{"v":7500,"d":"7500.00"},"","","","","",null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":20},94.3,0.04,0.04,0,0.04,0.02,0,null,null,0.01,7500.01,15000.01,22500.01,30000.01,37500.01,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":20},94.3999999999999,0.04,0.04,0,0.04,0.02,0,null,null,{"v":900,"d":"900.00"},{"v":15000,"d":"15000.00"},{"v":22500,"d":"22500.00"},{"v":30000,"d":"30000.00"},{"v":37500,"d":"37500.00"},{"v":45000,"d":"45000.00"},null,5,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":20},94.4999999999999,0.04,0.04,0,0.04,0.02,0,null,null,{"v":1620,"d":"1620.00"},{"v":15000,"d":"15000.00"},{"v":22500,"d":"22500.00"},{"v":30000,"d":"30000.00"},{"v":37500,"d":"37500.00"},{"v":45000,"d":"45000.00"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":20},94.5999999999999,0.04,0.04,0,0.04,0.04,0,null,null,{"v":2430,"d":"2430.00"},"","","","","",null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":20},94.6999999999999,0.04,0.04,0,0.04,0.04,0,null,null,{"v":7500,"d":"7500.00"},"","","","","",null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":20},94.7999999999999,0.04,0.04,0,0.04,0.04,0,{"$nulls":9},6,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":20},94.8999999999999,0.04,0.04,0,0.04,0.04,0,null,null,0.01,7500.01,15000.01,22500.01,30000.01,37500.01,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":20},94.9999999999999,0.04,0.04,0,0.04,0.04,0,null,null,{"v":900,"d":"900.00"},{"v":15000,"d":"15000.00"},{"v":22500,"d":"22500.00"},{"v":30000,"d":"30000.00"},{"v":37500,"d":"37500.00"},{"v":45000,"d":"45000.00"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":20},95.0999999999999,0.04,0.04,0,0.04,0.04,0,null,null,{"v":1620,"d":"1620.00"},"","","","",""]
[{"$nulls":20},95.1999999999999,0.04,0.04,0,0.04,0.04,0,null,null,{"v":2430,"d":"2430.00"},"","","","",""]
[{"$nulls":20},95.2999999999999,0.04,0.04,0,0.04,0.04,0,null,null,{"v":7500,"d":"7500.00"},"","","","","",null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":20},{"v":95.3999999999999,"d":"95.4"},0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},{"v":95.4999999999999,"d":"95.5"},0.04,0.04,0,0.04,0.04,0,null,null,{"v":899.99,"d":"900.0"},{"v":7499.99,"d":"7500.0"},{"v":7499.99,"d":"7500.0"},{"v":7499.990000000002,"d":"7500.0"},{"v":7499.990000000002,"d":"7500.0"},{"v":7499.989999999998,"d":"7500.0"}]
[{"$nulls":20},{"v":95.5999999999999,"d":"95.6"},0.04,0.04,0,0.04,0.04,0,null,null,{"v":720,"d":"720.0"},"","","","",""]
[{"$nulls":20},{"v":95.6999999999998,"d":"95.7"},0.04,0.04,0,0.04,0.04,0,null,null,{"v":810,"d":"810.0"},"","","","",""]
[{"$nulls":20},95.7999999999998,0.04,0.04,0,0.04,0.04,0,null,null,{"v":5070,"d":"5070.0"},"","","","",""]
[{"$nulls":20},95.8999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},95.9999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},96.0999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},96.1999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},96.2999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},96.3999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},96.4999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},96.5999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},96.6999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},{"v":96.7999999999998,"d":"96.8"},0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},{"v":96.8999999999998,"d":"96.9"},0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},{"v":96.9999999999998,"d":"97.0"},0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},{"v":97.0999999999998,"d":"97.1"},0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},97.1999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},97.2999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},97.3999999999997,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},97.4999999999997,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},97.5999999999997,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},97.6999999999997,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":22},0.04]
[{"$nulls":22},0.04]
[{"$nulls":22},0.04]
[{"$nulls":22},0.04]
[{"$nulls":22},0.04]

{"sheet":"Version II","index":1,"n_rows":181,"n_cols":50,"rows_kept":181,"merged":[[1,0,1,13],[2,0,2,13],[4,3,4,4],[4,5,4,6],[4,7,4,12],[5,1,5,2],[5,3,5,4],[5,10,5,12],[5,15,5,16],[7,1,7,2],[7,4,7,5],[7,7,7,11],[8,1,8,2],[8,4,8,5],[8,11,8,12],[9,1,9,2],[9,4,9,5],[10,1,10,2],[10,4,10,5],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,3,19,4],[19,6,19,7],[19,10,19,11],[20,11,20,12],[21,11,21,12],[22,11,22,12],[23,11,23,12],[24,11,24,12],[25,11,25,12],[26,11,26,12],[27,11,27,12],[28,11,28,12],[29,11,29,12],[30,11,30,12],[31,11,31,12],[32,11,32,12],[33,11,33,12],[34,11,34,12],[35,11,35,12],[36,11,36,12],[37,11,37,12],[38,11,38,12],[39,11,39,12],[40,11,40,12],[41,11,41,12],[42,11,42,12],[43,11,43,12],[44,11,44,12],[45,11,45,12],[46,1,46,2],[46,3,46,4],[46,5,46,6],[46,7,46,8],[46,10,46,13],[47,1,47,2],[47,3,47,4],[47,5,47,6],[47,7,47,8],[47,11,47,13],[48,1,48,2],[48,3,48,4],[48,5,48,6],[48,7,48,8],[48,10,48,13],[49,16,49,18],[50,2,53,12],[50,16,50,17],[56,8,56,10],[70,1,70,2]],"flags":["formulas_cached_only"]}
[null,"REVISED","2005-08-11"]
["SPEC. YEAR  \"2005\""]
["DENSITY  INCENTIVE / DISINCENTIVE   WORKSHEET  "]
[]
[null,null,"S.P.",null,null,"LOCATION",{"$nulls":17},0]
[null,"CONTRACTOR",{"$nulls":3},"PAVED",null,"CORED",null,null,"GYRATORY DESIGN"]
[]
[null,"BID PRICE=",null,{"v":2.5,"d":"$2.50"},"MAT THICKNESS =",null,null,""]
[null,"MIX  TYPE = ",null,"SPWER","TOTAL TONS PAVED =",null,50000,null,"OVERRIDE # LOTS = ",null,null,""]
[null,"Ave.Gmm.=",null,{"v":2.5,"d":"2.500"},"MAX. DENSITY TONS =",null,48000,"           LOTS REQUIRED =",null,6,null,null,5000]
[null,"TON TYPE ",null,"ENGLISH","INCENT/DISINC RATIO=",null,0.96,"            TONS PER LOT =",null,{"v":8000,"d":"8000.00"}]
[{"$nulls":7},"",null,""]
[null,"SAMPLE NUMBER",null,301,302,303,304,305,306,307,308,309,{"$nulls":3},"total tons"]
[null,"SAMPLE TON #",null,650,1567,2400,2820,3100,3500,3900,4500,4700,{"$nulls":3},50000]
[null,"TONS REPRESENTED",null,1567,833,420,280,400,400,600,200,45300,{"$nulls":3},"max density tons"]
[null,"DENSITY TONS",null,{"v":1504.32,"d":"1504"},{"v":799.68,"d":"800"},{"v":403.2,"d":"403"},{"v":268.8,"d":"269"},384,384,576,192,43488,{"$nulls":3},48000,{"$nulls":20},""]
[null,"INDIVIDUAL VOIDS",null,3.8,3.7,4.1,3.7,{"v":4,"d":"4.0"},{"v":4,"d":"4.0"},{"v":5,"d":"5.0"},4.4,{"v":4,"d":"4.0"},{"$nulls":3},"tons per lot"]
[null,"IND. MAX SP.G.",null,{"v":2.65,"d":"2.650"}]
[null,"MVNG AVG MX SP.G.",null,{"v":2.5,"d":"2.500"}]
[{"$nulls":3},"   DESIGN AIR VOIDS =",null,{"v":4,"d":"4.0"},"         MIN. AIR VOIDS =",null,3.5,null,"          REQ'D DENSITY=",null,{"v":91,"d":"91.0"},null,null,8000]
[{"$nulls":3},"CORE","Gmb /","BULK ","%","AIR VOID","TONS","Sq Yds","PAY","INCENTIVE",{"$nulls":3},"Adjusted Price per ton"]
[null,"LOT","CORE #","THICKNESS","BULK SP.G","SpG. USED","DENSITY","USED","REPRESENT.","REPRESENT","FACTOR","DISINCENTIVE",{"$nulls":3},{"v":2.5,"d":"2.50"}]
[null,22,22.1,{"v":2,"d":"2.00"},{"v":2.5,"d":"2.500"},{"v":2.5,"d":"2.500"},{"v":100,"d":"100.0"},{"v":4,"d":"4.0"},{"v":1504.31,"d":"1504.3"},"",{"v":0,"d":"0%"},{"v":0,"d":"$0.00"}]
[null,null,22.2,{"v":2.2,"d":"2.20"},{"v":2.5,"d":"2.500"},{"v":2.5,"d":"2.500"},null,{"v":4,"d":"4.0"},{"v":799.6800000000001,"d":"799.7"},"",{"v":0,"d":"0%"},{"v":0,"d":"$0.00"},{"$nulls":3},0]
[null,"COMP",22.1,{"v":2,"d":"2.00"},{"v":2.5,"d":"2.500"},"",null,{"v":4,"d":"4.0"},{"v":672,"d":"672.0"},"",{"v":0,"d":"0%"},{"v":0,"d":"$0.00"}]
[{"$nulls":3},{"v":2.066666666666667,"d":"2.07"},null,{"v":2.5,"d":"2.500"},"= Ave.Gmb.",{"v":4,"d":"4.0"},{"v":5024,"d":"5024.0"},"",{"v":0,"d":"0%"},{"v":0,"d":"$0.00"}]
[null,23,23.1,{"v":2,"d":"2.00"},{"v":2.2,"d":"2.200"},{"v":2.2,"d":"2.200"},87.6,{"v":4,"d":"4.0"},{"v":7999.99,"d":"8000.0"},"","SEE SPEC.","SEE SPEC."]
[null,null,23.2,1.42,{"v":2.18,"d":"2.180"},{"v":2.18,"d":"2.180"},null,"","",""," ",""]
[null,"COMP",null,{"v":2,"d":"2.00"},{"v":2.2,"d":"2.200"}," ",null,"","",""," ",""]
[{"$nulls":3},{"v":1.8066666666666666,"d":"1.81"},null,{"v":2.19,"d":"2.190"},"= Ave.Gmb.","","",""," ",""]
[null,24,24.1,null,null,"","","","",""," ",""]
[null,null,24.2,null,null,"",null,"","",""," ",""]
[null,"COMP",{"$nulls":3}," ",null,"","",""," ",""]
[{"$nulls":3},"",null,"","= Ave.Gmb.","","",""," ",""]
[null,25,25.1,null,null,"","","","",""," ",""]
[null,null,25.2,null,null,"",null,"","",""," ",""]
[null,"COMP",{"$nulls":3}," ",null,"","",""," ",""]
[{"$nulls":3},"",null,"","= Ave.Gmb.","","",""," ",""]
[null,26,26.1,null,null,"","","","",""," ",""]
[null,null,26.2,null,null,"",null,"","",""," ",""]
[null,"COMP",{"$nulls":3}," ",null,"","",""," ",""]
[{"$nulls":3},"",null,"","= Ave.Gmb.","","",""," ",""]
[null,27,27.1,null,null,"","","","",""," ",""]
[null,null,27.2,null,null,"",null,"","",""," ",""]
[null,"COMP",{"$nulls":3}," ",null,"","",""," ",""]
[{"$nulls":3},"",null,"","= Ave.Gmb.","","",""," ",""]
[null,"DATE:",{"$nulls":3},"CHECKED BY:",{"$nulls":4},"INCENTIVE / DISINCENTIVE"]
[null,"DATA  BY :",{"$nulls":3},"MIX DESIGNATION :",{"$nulls":4},"NET =",{"v":0,"d":"$0.00"}]
[null,"Average Density =",null,{"v":146.32799999999997,"d":"146.3"},null,"lbs.per square yd in.=",null,{"v":109.74599999999998,"d":"109.7"},null,null,"Weighted Average Air Voids"]
[]
[null,"NOTES"]
[null,{"v":4,"d":"4.0"}]
[]
[]
[]
[]
[]
[{"$nulls":3},"Would you like to calculate and use the weighted average"]
[{"$nulls":3},"of the production air voids, rather than using the individual "]
[{"$nulls":3},"air voids?  The incentive/disincentive calculated using this"]
[{"$nulls":3},"option is to be used for information only.  The specification "]
[{"$nulls":3},"calls for using the individual air voids and the weighted average"]
[{"$nulls":3},"method should NOT be used to calculate the actual ",{"$nulls":25},"yes"]
[{"$nulls":3},"incentive/disincentive to be paid to the contractor.",{"$nulls":25},"no"]
[{"$nulls":21},2350,2350,2350,2360,2360,2360]
[{"$nulls":3},"I would like to use the weighted average of the air voids - ",{"$nulls":6},"yes",{"$nulls":9},"%DENS.",-1,2,"RED. (3)","upper 4\" (4)","lower 4\"(5)",6]
[{"$nulls":21},"hv","MV LV"," MV LV",">4\" REDUCED",null,"up 4\" red.",null,null,"MIN.VOID","REQ. DENS.","DEN.COL.","INCENT*","VOID LIMIT"]
[{"$nulls":4},"air void weighted average = ",null,null,{"v":4,"d":"4.0"},{"$nulls":14},"SP WEAR,SHLD","SP WEAR,SHLD",{"$nulls":4},"LV",2.5,{"v":92,"d":"92.0"},2,2,1]
[{"$nulls":20},87,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"LVR",2.5,{"v":91,"d":"91.0"},3,2,1,{"$nulls":10},"TONS PAVED (metric) =",null,48000,null,{"v":0,"d":"0.0"},{"v":3.8,"d":"3.80"}]
["max",null,"a",1,2,3,4,5,6,7,8,9,{"$nulls":8},87.1,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"MV",{"v":3,"d":"3.0"},{"v":92,"d":"92.0"},2,2,2,{"$nulls":10},"     LOTS tested =",null,6,null,{"v":1504.32,"d":"1504.3"},{"v":3.7,"d":"3.70"}]
["average","average mx spg",null,{"v":2.65,"d":"2.650"},1.325,0.883,0.662,{"v":0.53,"d":"0.530"},0.442,0.379,0.331,0.294,{"$nulls":8},87.2,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"MVR",{"v":3,"d":"3.0"},{"v":91,"d":"91.0"},3,2,2,{"$nulls":10},"        TONS PER LOT=",null,{"v":8000,"d":"8000.00"},null,{"v":2304,"d":"2304.0"},{"v":4.1,"d":"4.10"}]
[null,"is average available",null,1,0,0,0,0,0,0,0,0,{"$nulls":8},87.3,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"SPNW",2.5,{"v":93,"d":"93.0"},5,2,1,"NONWEAR",1,{"$nulls":10},3.5,null,2707.2,{"v":3.7,"d":"3.70"}]
[null,"number of max's",null,1,{"$nulls":16},87.4,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"SPNWR",2.5,{"v":92,"d":"92.0"},6,1,1,"NW",1,{"$nulls":6},"",null,{"v":2.5,"d":"$2.50"},null,{"v":91,"d":"91.0"},null,{"v":2976,"d":"2976.0"},{"v":4,"d":"4.00"}]
[{"$nulls":20},87.5,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"SPSHLD3",2.5,93,5,2,1,"WEAR",2,{"$nulls":12},{"v":3360,"d":"3360.0"},{"v":4,"d":"4.00"}]
[null,"look up the avg",null,2.65,{"$nulls":16},87.6,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"SPSHLD3R",2.5,92,6,1,1,{"$nulls":14},{"v":3744,"d":"3744.0"},{"v":5,"d":"5.00"}]
[{"$nulls":20},87.7,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"SPSHLD4",3.5,92,2,2,3,{"$nulls":14},{"v":4320,"d":"4320.0"},{"v":4.4,"d":"4.40"}]
[{"$nulls":3},1,2,3,4,5,6,7,8,9,{"$nulls":8},87.8,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"SPSHLD4R",3.5,91,3,2,2,"VOID LIMIT",3,"Q/C","SAMPLE #",1,2,3,4,5,6,7,8,9,null,{"v":4512,"d":"4512.0"},{"v":4,"d":"4.00"}]
[{"$nulls":3},{"v":2.5,"d":"2.500"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"$nulls":8},87.9,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"SPWE",3.5,{"v":92,"d":"92.0"},2,2,3,"DENSITY",3,"SAMPLES","TON #",650,1567,2400,2820,3100,3500,3900,4500,4700,null,48000.1]
[{"$nulls":3},1,0,0,0,0,0,0,0,0,{"$nulls":8},88,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"SPWER",3.5,{"v":91,"d":"91.0"},3,2,3,"INCENT.",2,null,"TONS REP.",1567,833,420,280,400,400,600,200,45300]
[{"$nulls":3},1,{"$nulls":16},88.1,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",{"$nulls":3},"INCENT* - 1 = N0, 2 = YES",{"$nulls":6},"MAX TONS",{"v":1504.32,"d":"1504"},{"v":799.68,"d":"800"},{"v":403.2,"d":"403"},{"v":268.8,"d":"269"},384,384,576,192,43488]
[{"$nulls":3},2.5,{"$nulls":16},88.2,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",{"$nulls":3},"VOID LIMIT - 3 = 3.5%MIN, 2 = 3%MIN, 1 = 2.5%MIN.",{"$nulls":6},"AIR VOIDS",{"v":3.8,"d":"3.80"},{"v":3.7,"d":"3.70"},{"v":4.1,"d":"4.10"},{"v":3.7,"d":"3.70"},{"v":4,"d":"4.00"},{"v":4,"d":"4.00"},{"v":5,"d":"5.00"},{"v":4.4,"d":"4.40"},{"v":4,"d":"4.00"}]
[{"$nulls":20},88.3,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"ENGLISH",{"$nulls":20},{"v":48000,"d":"48000.0"}]
[{"$nulls":20},88.4,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"METRIC",{"$nulls":4},"LOT #",{"$nulls":6},"PRICE  ADJ.","DENSITY","AIR VOID","TONS","FACTOR","in/dis",{"$nulls":3},{"v":48000,"d":"48000.0"}]
[{"$nulls":20},88.5,-0.3,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",{"$nulls":6},1,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0,{"v":2.5,"d":"2.500"},{"v":0,"d":"$0.00"},{"v":100,"d":"100.0"},{"v":4,"d":"4.00"},{"v":1504.31,"d":"1504.3"},0,{"v":0,"d":"0.00"},0,null,null,{"v":1504.31,"d":"1504.3"}]
[{"$nulls":20},88.6,-0.3,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",{"$nulls":7},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,{"v":2.5,"d":"2.500"},{"v":0,"d":"$0.00"},null,{"v":4,"d":"4.00"},{"v":799.6800000000001,"d":"799.7"},0,{"v":0,"d":"0.00"},0,null,null,{"v":2303.99,"d":"2304.0"}]
[{"$nulls":20},88.7,-0.3,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"english",2,null,"ton type",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"$0.00"},null,{"v":4,"d":"4.00"},{"v":672,"d":"672.0"},0,{"v":0,"d":"0.00"},0,null,null,{"v":2975.99,"d":"2976.0"}]
[{"$nulls":20},88.8,-0.3,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"metric",1,null,2,{"$nulls":8},{"v":0,"d":"$0.00"},null,{"v":4,"d":"4.00"},{"v":5024,"d":"5024.0"},0,{"v":0,"d":"0.00"},0,null,null,{"v":7999.99,"d":"8000.0"}]
[{"$nulls":20},88.9,-0.3,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",{"$nulls":6},2,{"v":0,"d":"0.00"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"SEE SPEC.",{"v":2.2,"d":"2.200"},"0",87.6,{"v":4,"d":"4.00"},{"v":7999.99,"d":"8000.0"},"SEE SPEC.","SEE SPEC.","SEE SPEC.",null,null,{"v":15999.98,"d":"16000.0"}]
[{"$nulls":20},{"v":89,"d":"89.0"},-0.15,-0.3,-0.3,{"v":-0.3,"d":"-0.30"},"SEE SPEC.",-0.3,{"$nulls":7},{"v":0,"d":"0.00"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"v":2.18,"d":"2.180"},"0",null,"","","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,null,{"v":15999.98,"d":"16000.0"}]
[{"$nulls":20},89.1,-0.15,-0.3,-0.3,{"v":-0.3,"d":"-0.30"},"SEE SPEC.",-0.3,null,"Tons","Lots","ENGLISH",{"$nulls":3},{"v":0,"d":"0.00"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,"0",null,"","","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,null,{"v":15999.98,"d":"16000.0"}]
[{"$nulls":20},89.2,-0.15,-0.3,-0.15,{"v":-0.3,"d":"-0.30"},"SEE SPEC.",-0.3,null,0.1,0,0.1,0,{"$nulls":8},"0",null,"","","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,null,{"v":15999.98,"d":"16000.0"}]
[{"$nulls":20},89.3,-0.15,-0.3,-0.15,{"v":-0.3,"d":"-0.30"},"SEE SPEC.",-0.3,null,1,1,1,1,null,3,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"v":0,"d":"0.000"},{"$error":"#N/A"},"",{"v":4,"d":"4.00"},{"v":7999.99,"d":"8000.0"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":23999.97,"d":"24000.0"}]
[{"$nulls":20},89.4,-0.15,-0.3,-0.09,{"v":-0.3,"d":"-0.30"},"SEE SPEC.",-0.3,null,546,2,601,2,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"v":0,"d":"0.000"},{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":23999.97,"d":"24000.0"}]
[{"$nulls":20},89.5,-0.09,-0.15,-0.09,-0.15,"SEE SPEC.",-0.15,null,911,3,1001,3,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":23999.97,"d":"24000.0"}]
[{"$nulls":20},89.6,-0.09,-0.15,-0.09,-0.15,"SEE SPEC.",-0.15,null,1456,4,1601,4,{"$nulls":8},{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":23999.97,"d":"24000.0"}]
[{"$nulls":20},89.7,-0.09,-0.15,-0.05,-0.15,"SEE SPEC.",-0.15,null,3276,5,3601,5,null,4,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"v":0,"d":"0.000"},{"$error":"#N/A"},"",{"v":4,"d":"4.00"},{"v":7999.990000000002,"d":"8000.0"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":31999.960000000003,"d":"32000.0"}]
[{"$nulls":20},89.8,-0.09,-0.15,-0.05,-0.15,"SEE SPEC.",-0.15,null,4546,6,5001,6,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"v":0,"d":"0.000"},{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":31999.960000000003,"d":"32000.0"}]
[{"$nulls":20},89.9,-0.09,-0.15,-0.05,-0.15,"SEE SPEC.",-0.15,null,9999,6,9999,6,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":31999.960000000003,"d":"32000.0"}]
[{"$nulls":20},90,-0.05,-0.09,-0.02,-0.09,{"v":-0.3,"d":"-0.30"},-0.09,{"$nulls":13},{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":31999.960000000003,"d":"32000.0"}]
[{"$nulls":20},90.1,-0.05,-0.09,-0.02,-0.09,{"v":-0.3,"d":"-0.30"},-0.09,{"$nulls":6},5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"v":0,"d":"0.000"},{"$error":"#N/A"},"",{"v":4,"d":"4.00"},{"v":7999.990000000002,"d":"8000.0"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":39999.950000000004,"d":"40000.0"}]
[{"$nulls":20},90.2,-0.05,-0.09,-0.02,-0.09,{"v":-0.3,"d":"-0.30"},-0.09,{"$nulls":7},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"v":0,"d":"0.000"},{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":39999.950000000004,"d":"40000.0"}]
[{"$nulls":20},90.3,-0.05,-0.09,-0.02,-0.09,{"v":-0.3,"d":"-0.30"},-0.09,{"$nulls":7},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":39999.950000000004,"d":"40000.0"}]
[{"$nulls":20},90.4,-0.05,-0.09,-0.02,-0.09,{"v":-0.3,"d":"-0.30"},-0.09,{"$nulls":13},{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":39999.950000000004,"d":"40000.0"}]
[{"$nulls":20},90.5,-0.02,-0.05,-0.02,-0.05,-0.15,-0.05,{"$nulls":6},6,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"v":0,"d":"0.000"},{"$error":"#N/A"},"",{"v":4,"d":"4.00"},{"v":7999.989999999998,"d":"8000.0"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":47999.94,"d":"47999.9"}]
[{"$nulls":20},90.6,-0.02,-0.05,-0.02,-0.05,-0.15,-0.05,{"$nulls":7},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"v":0,"d":"0.000"},{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":47999.94,"d":"47999.9"}]
[{"$nulls":20},90.7,-0.02,-0.05,-0.02,-0.05,-0.15,-0.05,{"$nulls":7},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":47999.94,"d":"47999.9"}]
[{"$nulls":20},90.8,-0.02,-0.05,-0.02,-0.05,-0.15,-0.05,{"$nulls":13},{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":47999.94,"d":"47999.9"}]
[{"$nulls":20},90.9,-0.02,-0.05,-0.02,-0.05,-0.15,-0.05]
[{"$nulls":20},91,-0.02,-0.02,0,-0.02,-0.09,-0.02]
[{"$nulls":20},91.1,-0.02,-0.02,0,-0.02,-0.09,-0.02]
[{"$nulls":20},91.2,-0.02,-0.02,0,-0.02,-0.09,-0.02,null,"SAMPLE ","LOT 1","LOT 2","LOT 3","LOT 4","LOT 5","LOT 6",null,"S.P."]
[{"$nulls":20},91.3,-0.02,-0.02,0,-0.02,-0.09,-0.02,null,"TON",{"$nulls":7},"S.A.P"]
[{"$nulls":20},91.4,-0.02,-0.02,0,-0.02,-0.09,-0.02,null,"samples",{"v":8000,"d":"8000.00"},{"v":16000,"d":"16000.00"},{"v":24000,"d":"24000.00"},{"v":32000,"d":"32000.00"},{"v":40000,"d":"40000.00"},{"v":48000,"d":"48000.00"},null,"C.P."]
[{"$nulls":20},91.5,0,-0.02,0,-0.02,-0.05,-0.02,null,1504.32,1504.32,"","","","","",null,6]
[{"$nulls":20},91.6,0,-0.02,0,-0.02,-0.05,-0.02,null,{"v":2304,"d":"2304.00"},{"v":2304,"d":"2304.00"},"","","","","",null,"LV","MARSHALL DESIGN"]
[{"$nulls":20},91.7,0,-0.02,0,-0.02,-0.05,-0.02,null,{"v":2707.2,"d":"2707.20"},{"v":2707.2,"d":"2707.20"},"","","","","",null,"LVR","MARSHALL DESIGN"]
[{"$nulls":20},91.8,0,-0.02,0,-0.02,-0.05,-0.02,null,{"v":2976,"d":"2976.00"},{"v":2976,"d":"2976.00"},"","","","","",null,"MV","MARSHALL DESIGN"]
[{"$nulls":20},91.9,0,-0.02,0,-0.02,-0.05,-0.02,null,{"v":3360,"d":"3360.00"},"","","","","","",null,"MVR","MARSHALL DESIGN"]
[{"$nulls":20},92,0,0,0,{"v":0,"d":"0.00"},-0.02,0,null,{"v":3744,"d":"3744.00"},"","","","","","",null,"SPNW","GYRATORY DESIGN"]
[{"$nulls":20},92.1,0,0,0,{"v":0,"d":"0.00"},-0.02,0,null,{"v":4320,"d":"4320.00"},"","","","","","",null,"SPNWR","GYRATORY DESIGN"]
[{"$nulls":20},92.2,0,0,0,{"v":0,"d":"0.00"},-0.02,0,null,{"v":4512,"d":"4512.00"},"","","","","","",null,"SPSHLD3","GYRATORY DESIGN"]
[{"$nulls":20},92.3,0,0,0,{"v":0,"d":"0.00"},-0.02,0,null,null,0.01,8000.01,16000.01,24000.01,32000.01,40000.01,null,"SPSHLD4","GYRATORY DESIGN"]
[{"$nulls":20},92.4,0,0,0,{"v":0,"d":"0.00"},-0.02,0,null,null,1504.32,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,"SPSHLD3R","GYRATORY DESIGN"]
[{"$nulls":20},92.5,0,0,0,{"v":0,"d":"0.00"},-0.02,0,null,null,{"v":2304,"d":"2304.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,"SPSHLD4R","GYRATORY DESIGN"]
[{"$nulls":20},92.6,0.02,0,0,{"v":0,"d":"0.00"},-0.02,0,null,null,{"v":2976,"d":"2976.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,"SPWE","GYRATORY DESIGN"]
[{"$nulls":20},92.7,0.02,0,0,{"v":0,"d":"0.00"},-0.02,0,null,null,{"v":8000,"d":"8000.00"},{"v":16000,"d":"16000.00"},{"v":24000,"d":"24000.00"},{"v":32000,"d":"32000.00"},{"v":40000,"d":"40000.00"},{"v":48000,"d":"48000.00"},null,"SPWER","GYRATORY DESIGN"]
[{"$nulls":20},92.8,0.02,0,0,{"v":0,"d":"0.00"},-0.02,0,null,null,0.01,8000.01,16000.01,24000.01,32000.01,40000.01,null,1,{"v":0,"d":"0.00"},""]
[{"$nulls":20},92.9,0.02,0,0,{"v":0,"d":"0.00"},-0.02,0,null,null,1504.32,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},""]
[{"$nulls":20},93,0.02,0,0,{"v":0,"d":"0.00"},0,0,null,null,{"v":2304,"d":"2304.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},""]
[{"$nulls":20},93.1,0.04,0.02,0,0.02,0,0,null,null,{"v":2976,"d":"2976.00"},{"v":16000,"d":"16000.00"},{"v":24000,"d":"24000.00"},{"v":32000,"d":"32000.00"},{"v":40000,"d":"40000.00"},{"v":48000,"d":"48000.00"},null,null,{"v":0,"d":"0.00"},""]
[{"$nulls":20},93.2,0.04,0.02,0,0.02,0,0,null,null,8000,"","","","","",null,2,"SEE SPEC.",""]
[{"$nulls":20},93.3,0.04,0.02,0,0.02,0,0,null,null,0.01,8000.01,16000.01,24000.01,32000.01,40000.01,null,null,"",""]
[{"$nulls":20},93.4,0.04,0.02,0,0.02,0,0,null,null,1504.32,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,null,"",""]
[{"$nulls":20},93.5,0.04,0.02,0,0.02,0,0,null,null,{"v":2304,"d":"2304.00"},{"v":16000,"d":"16000.00"},{"v":24000,"d":"24000.00"},{"v":32000,"d":"32000.00"},{"v":40000,"d":"40000.00"},{"v":48000,"d":"48000.00"},null,null,"",""]
[{"$nulls":20},93.6,0.04,0.04,0,0.04,0,0,null,null,{"v":2976,"d":"2976.00"},{"v":16000,"d":"16000.00"},{"v":24000,"d":"24000.00"},{"v":32000,"d":"32000.00"},{"v":40000,"d":"40000.00"},{"v":48000,"d":"48000.00"},null,3,"",""]
[{"$nulls":20},93.7,0.04,0.04,0,0.04,0,0,null,null,{"v":8000,"d":"8000.00"},"","","","","",null,null,"",""]
[{"$nulls":20},93.8,0.04,0.04,0,0.04,0,0,null,null,0.01,8000.01,16000.01,24000.01,32000.01,40000.01,null,null,"",""]
[{"$nulls":20},93.9,0.04,0.04,0,0.04,0,0,null,null,1504.32,{"v":16000,"d":"16000.00"},{"v":24000,"d":"24000.00"},{"v":32000,"d":"32000.00"},{"v":40000,"d":"40000.00"},{"v":48000,"d":"48000.00"},null,null,"",""]
[{"$nulls":20},{"v":94,"d":"94.0"},0.04,0.04,0,0.04,0,0,null,null,{"v":2304,"d":"2304.00"},{"v":16000,"d":"16000.00"},{"v":24000,"d":"24000.00"},{"v":32000,"d":"32000.00"},{"v":40000,"d":"40000.00"},{"v":48000,"d":"48000.00"},null,4,"",""]
[{"$nulls":20},94.1,0.04,0.04,0,0.04,0.02,0,null,null,{"v":2976,"d":"2976.00"},{"v":16000,"d":"16000.00"},{"v":24000,"d":"24000.00"},{"v":32000,"d":"32000.00"},{"v":40000,"d":"40000.00"},{"v":48000,"d":"48000.00"},null,null,"",""]
[{"$nulls":20},94.2,0.04,0.04,0,0.04,0.02,0,null,null,{"v":8000,"d":"8000.00"},"","","","","",null,null,"",""]
[{"$nulls":20},94.3,0.04,0.04,0,0.04,0.02,0,null,null,0.01,8000.01,16000.01,24000.01,32000.01,40000.01,null,null,"",""]
[{"$nulls":20},94.3999999999999,0.04,0.04,0,0.04,0.02,0,null,null,1504.32,{"v":16000,"d":"16000.00"},{"v":24000,"d":"24000.00"},{"v":32000,"d":"32000.00"},{"v":40000,"d":"40000.00"},{"v":48000,"d":"48000.00"},null,5,"",""]
[{"$nulls":20},94.4999999999999,0.04,0.04,0,0.04,0.02,0,null,null,{"v":2304,"d":"2304.00"},{"v":16000,"d":"16000.00"},{"v":24000,"d":"24000.00"},{"v":32000,"d":"32000.00"},{"v":40000,"d":"40000.00"},{"v":48000,"d":"48000.00"},null,null,"",""]
[{"$nulls":20},94.5999999999999,0.04,0.04,0,0.04,0.04,0,null,null,{"v":2976,"d":"2976.00"},"","","","","",null,null,"",""]
[{"$nulls":20},94.6999999999999,0.04,0.04,0,0.04,0.04,0,null,null,{"v":8000,"d":"8000.00"},"","","","","",null,null,"",""]
[{"$nulls":20},94.7999999999999,0.04,0.04,0,0.04,0.04,0,{"$nulls":9},6,"",""]
[{"$nulls":20},94.8999999999999,0.04,0.04,0,0.04,0.04,0,null,null,0.01,8000.01,16000.01,24000.01,32000.01,40000.01,null,null,"",""]
[{"$nulls":20},94.9999999999999,0.04,0.04,0,0.04,0.04,0,null,null,1504.32,{"v":16000,"d":"16000.00"},{"v":24000,"d":"24000.00"},{"v":32000,"d":"32000.00"},{"v":40000,"d":"40000.00"},{"v":48000,"d":"48000.00"},null,null,"",""]
[{"$nulls":20},95.0999999999999,0.04,0.04,0,0.04,0.04,0,null,null,{"v":2304,"d":"2304.00"},"","","","",""]
[{"$nulls":20},95.1999999999999,0.04,0.04,0,0.04,0.04,0,null,null,{"v":2976,"d":"2976.00"},"","","","",""]
[{"$nulls":20},95.2999999999999,0.04,0.04,0,0.04,0.04,0,null,null,{"v":8000,"d":"8000.00"},"","","","","",null,null,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[{"$nulls":20},{"v":95.3999999999999,"d":"95.4"},0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},{"v":95.4999999999999,"d":"95.5"},0.04,0.04,0,0.04,0.04,0,null,null,{"v":1504.31,"d":"1504.3"},{"v":7999.99,"d":"8000.0"},{"v":7999.99,"d":"8000.0"},{"v":7999.990000000002,"d":"8000.0"},{"v":7999.990000000002,"d":"8000.0"},{"v":7999.989999999998,"d":"8000.0"}]
[{"$nulls":20},{"v":95.5999999999999,"d":"95.6"},0.04,0.04,0,0.04,0.04,0,null,null,{"v":799.6800000000001,"d":"799.7"},"","","","",""]
[{"$nulls":20},{"v":95.6999999999998,"d":"95.7"},0.04,0.04,0,0.04,0.04,0,null,null,{"v":672,"d":"672.0"},"","","","",""]
[{"$nulls":20},95.7999999999998,0.04,0.04,0,0.04,0.04,0,null,null,{"v":5024,"d":"5024.0"},"","","","",""]
[{"$nulls":20},95.8999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},95.9999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},96.0999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},96.1999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},96.2999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},96.3999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},96.4999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},96.5999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},96.6999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},{"v":96.7999999999998,"d":"96.8"},0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},{"v":96.8999999999998,"d":"96.9"},0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},{"v":96.9999999999998,"d":"97.0"},0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},{"v":97.0999999999998,"d":"97.1"},0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},97.1999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},97.2999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},97.3999999999997,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},97.4999999999997,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},97.5999999999997,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},97.6999999999997,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":22},0.04]
[{"$nulls":22},0.04]
[{"$nulls":22},0.04]
[{"$nulls":22},0.04]
[{"$nulls":22},0.04]

{"sheet":"Split Production","index":2,"n_rows":50,"n_cols":19,"rows_kept":50,"merged":[[6,2,6,3],[7,2,7,3],[7,8,7,11],[8,2,8,3],[10,2,10,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,4,18,5],[18,7,18,8],[18,10,18,11],[19,11,19,12],[20,11,20,12],[21,11,21,12],[22,11,22,12],[23,11,23,12],[25,11,25,12],[26,2,26,3],[27,2,27,3],[29,2,29,3],[29,5,29,6],[30,11,30,12],[31,2,31,3],[32,2,32,3],[33,2,33,3],[35,11,35,12],[36,2,36,3],[37,2,37,3],[38,2,38,3],[39,11,39,12],[40,2,40,3],[41,2,41,3],[42,2,42,3],[45,2,45,3],[45,5,45,6],[47,2,47,3],[48,2,48,3],[49,2,49,3],[50,11,50,12],[51,11,51,12],[52,11,52,12],[53,2,53,3],[53,4,53,5],[53,6,53,7],[53,8,53,9],[53,10,53,13],[54,2,54,3],[54,4,54,5],[54,6,54,7],[54,8,54,9],[54,11,54,13],[55,2,55,3],[55,4,55,5],[55,6,55,7],[55,8,55,9],[57,3,57,12],[57,16,57,18],[58,3,58,12],[58,16,58,17],[60,3,60,12],[63,9,63,10]],"flags":["formulas_cached_only"]}
[]
[null,null,"Split Production  -  The following worksheet can be used when a day's production needs to be split due to "]
[null,null,"different density requirements or similar situations.  Area \"A\" is defined as the first area paved from the start "]
[null,null,"of that day's production and Area \"B\" is the remaining tonnage for that day's production.  The number of lots",{"$nulls":14},"ENGLISH"]
[null,null,"required for each area may be manually entered on each worksheet.  The intent is to not have more lots tested ",{"$nulls":14},0.1,0]
[null,null,"than the required amount for the total day's production.",{"$nulls":14},1,1]
[{"$nulls":17},601,2]
[{"$nulls":5},"DAILY TOTAL TONS PAVED =",null,6000,"      # OF LOTS REQ'D FOR DAILY TOTAL =",{"$nulls":3},6,{"$nulls":4},1001,3]
[{"$nulls":5},"AREA \"A\" -  TONS PAVED =",null,2150,{"$nulls":9},1601,4]
[{"$nulls":5},"AREA \"B\" -  TONS PAVED =",null,3850,{"$nulls":9},3601,5]
[{"$nulls":4},"COMPLETE TEST DATA TAKEN FROM THE TEST SUMMARY SHEETS",{"$nulls":12},5001,6]
[]
[null,null,"SAMPLE NUMBER",null,301,302,303,304,305,306,307,308,309]
[null,null,"SAMPLE TON #",null,650,1567,2400,2820,3444,4001,4567,5221,5900]
[null,"B","TONS - 1ST SECTION",null,2150,2150,2150,2150,2150,2150,2150,2150,2150]
[null,"C","SAMPLE TON # 1ST SECT.",null,650,1567,2000,2000,2000,2000,2000,2000,2000]
[null,"D","SAMPLE TON # 2nd SECT.",null,0,0,400,8200,1444,2001,2567,3221,3900]
[null,null,"INDIVIDUAL VOIDS",null,3.8,3.7,4.1,3.7,{"v":3,"d":"3.0"},{"v":2,"d":"2.0"},{"v":5,"d":"5.0"},4.4,{"v":2,"d":"2.0"}]
[]
[]
[null,"A",{"$nulls":16},4]
[null,"B","The number of tons that represent the first section.  Insert this value in the total tons paved.",{"$nulls":15},5]
[null,"C","Compare the A and B values, insert the lessor value.",{"$nulls":15},6]
[null,"D","C minus A",{"$nulls":15},6]
[]
[]
[null,null,"SAMPLE NUMBER",null,301,302,303,304,305,306,307,308,309]
[null,null,"SAMPLE TON #",null,650,1567,2150,2150,2150,2150,2150,2150,2150]
[]
[null,null,"AREA \"A\"",null,"Notes","TOTAL TONS PAVED =",null,2150,null,"NUMBER OF LOTS - MANUAL =",null,2]
[]
[null,null,"SAMPLE NUMBER",null,301,302,"","","","","","",""]
[null,null,"SAMPLE TON #",null,650,1567,"","","","","","",""]
[null,null,"INDIVIDUAL VOIDS",null,3.8,3.7,"","","","","","",""]
[]
[]
[null,null,"SAMPLE NUMBER",null,301,302,303,304,305,306,307,308,309]
[null,null,"SAMPLE TON #",null,0,0,250,670,1294,1851,2417,3071,3750]
[null,null,"INDIVIDUAL VOIDS",null,3.8,3.7,4.1,3.7,{"v":3,"d":"3.0"},{"v":2,"d":"2.0"},{"v":5,"d":"5.0"},4.4,{"v":2,"d":"2.0"}]
[]
[null,null,"SAMPLE NUMBER",null,302,303,304,305,306,307,308,309,310]
[null,null,"SAMPLE TON #",null,0,250,670,1294,1851,2417,3071,3750,3750]
[null,null,"INDIVIDUAL VOIDS",null,3.7,4.1,3.7,{"v":3,"d":"3.0"},{"v":2,"d":"2.0"},{"v":5,"d":"5.0"},4.4,{"v":2,"d":"2.0"},{"v":2,"d":"2.0"}]
[]
[]
[null,null,"AREA \"B\"",null,null,"TOTAL TONS PAVED =",null,3850,null,"NUMBER OF LOTS - MANUAL =",null,4]
[]
[null,null,"SAMPLE NUMBER",null,302,303,304,305,306,307,308,309,""]
[null,null,"SAMPLE TON #",null,0,250,670,1294,1851,2417,3071,3750,""]
[null,null,"INDIVIDUAL VOIDS",null,3.7,4.1,3.7,{"v":3,"d":"3.0"},{"v":2,"d":"2.0"},{"v":5,"d":"5.0"},4.4,{"v":2,"d":"2.0"},""]

{"sheet":"INSTRUCTIONS","index":3,"n_rows":103,"n_cols":3,"rows_kept":103,"merged":[[3,0,3,9],[60,1,62,9]],"flags":["formulas_cached_only"]}
[]
[]
[]
["IMPROVEMENTS TO THE INCENTIVE / DISINCENTIVE PROGRAM"]
[]
[null,"THIS PROGRAM HAS BEEN MODIFIED TO ALLOW WORKSHEETS"]
[null,"TO BE COPIED WITHIN THE WORKBOOK,  THEREFORE ONE"]
[null,"WORKBOOK (OR FILE) CAN CONTAIN SEVERAL DAYS OF PAVING."]
[]
[null,"THE DATA FOR DAY #1 SHOULD BE ENTERED ON THE  SHEET"]
[null,"LABELED \"day (1)\".  FOR DAYS THAT FOLLOW, MAKE A COPY"]
[null,"OF THIS SHEET BY USING ONE OF THE FOLLOWING THREE METHODS."]
[]
[null,"METHOD  1"]
[null,"CLICK ON THE BUTTON TO THE RIGHT"]
[]
[null,null,"OR"]
[]
[null,"METHOD  2"]
[null,"CLICK TO THE WORKSHEET YOU WOULD LIKE TO COPY, MOVE"]
[null,"THE CURSOR DOWN TO THE TAB AT THE BOTTOM OF THE SHEET,"]
[null,"THE CURSOR WILL CHANGE TO AN ARROW TYPE FORM, THE  "]
[null,"HOLD THE CTRL (CONTROL) DOWN AND THEN LEFT CLICK AND "]
[null,"DOWN AND DRAG TO THE RIGHT."]
[]
[null,null,"OR"]
[]
[null,"METHOD  3"]
[null,"CLICK TO THE WORKSHEET YOU WOULD LIKE TO COPY, MOVE"]
[null,"THE CURSOR DOWN TO THE TAB AT THE BOTTOM OF THE SHEET,"]
[null,"THE CURSOR WILL CHANGE TO AN ARROW TYPE FORM, THEN  "]
[null,"RIGHT CLICK, CLICK ON THE COPY/MOVE BUTTON, CLICK OR CHECK"]
[null,"THE CREATE A COPY BOX AND THEN CLICK ON OK."]
[]
[]
[null,"RENAME A WORKSHEET"]
[null,"CLICK TO THE WORKSHEET YOU WOULD LIKE TO RENAME, MOVE"]
[null,"THE CURSOR DOWN TO THE TAB AT THE BOTTOM OF THE SHEET,"]
[null,"THE CURSOR WILL CHANGE TO AN ARROW TYPE FORM, THEN  "]
[null,"RIGHT CLICK, CLICK ON THE RENAME BUTTON, THEN TYPE IN THE"]
[null,"NEW WORKSHEET NAME, ( some typing characters may not be allowed in a "]
[null,"name due to their formula type functions).   THEN PRESS ENTER."]
[]
[]
[null,"MOVING A WORKSHEET WITHIN A WORKBOOK."]
[null,"CLICK TO THE WORKSHEET YOU WOULD LIKE TO RENAME, MOVE"]
[null,"THE CURSOR DOWN TO THE TAB AT THE BOTTOM OF THE SHEET,"]
[null,"THE CURSOR WILL CHANGE TO AN ARROW TYPE FORM, THEN  "]
[null,"LEFT CLICK AND HOLD DOWN, WITH THE BOTTON DOWN YOU CAN "]
[null,"MOVE THE CURSOR TO THE RIGHT OR LEFT TO POSITION THE "]
[null,"WORKSHEET TO THE NEEDED POSITION."]
[]
[]
[null,"Revision History"]
[]
[null,"Revision for 8/8/2002 - this is the first published version to have the dual formats,"]
[null,"with and without the lab worksheet incorporated"]
[null,"This version also has added a flag for the incentive/disincentive to warn when"]
[null,"a bid price has not been included"]
[null,"zzzz"]
[null,"Revision for 8/27/02 - fixed the buttons for the copying macros\nfixed the date fields to be shink to fit"]
[]
[]
[]
[null,"Revision for 11/13/02 - this version includes the manual overide for the number of "]
[null,"lots.  Leave \"0\" in the overide cell to accept the standard number of lots."]
[]
[null,"Revision for 11/14/02 - this version includes a facility for cutting and pasting data"]
[null,"into future revisions of this spread sheet.  This facility is made possible by the "]
[null,"following macros and buttons:  \"copy_data\", \"paste_data\", \"buttons_off\", "]
[null,null,"\"buttons_on\", \"copy_data_page2\", \"paste_data_page2\", "]
[null,null,"button_3, button_4, button_26, button_27, button_53, button_54"]
[null,"and the addition of another sheet: \"Sheet1\""]
[null,"The addition of these items to an old spread sheet should give it the facility "]
[null,"to paste data into a version of this spread sheet.  The formatting from the "]
[null,"respective sheets (\"combined\" and \"incentive\") should be pasted into the sheet"]
[null,"\"Sheet1\".  The formatting for \"incentive\" should be copied from \"A1:m53\" and pasted"]
[null,"to \"Sheet1\" starting at cell \"a1\".  The formatting for \"combined\" should be copied"]
[null,"from \"a1:r45\" and pasted to \"Sheet1\" starting at \"aa1\"."]
[]
[null,"Revision for 7/21/03 - this revision only effects the spread sheet if you are using "]
[null,"the weighted average of airvoids option.  Calculations of the weighted average "]
[null,"airvoids is causing error when blanks are used in the calculation.  Zeros are going"]
[null,"to be used as place holders, instead of \"\" blanks.  This will make the calculations"]
[null,"work.  A conditional format will make the zeros look invisible.  See the formulas"]
[null,"in cells D10:L11 for version I and cells D15:l16 for version II"]
[]
[null,"Revision for 9/4/03 - this revision reformated the \"notes\" fields.  I merged the "]
[null,"cells and set the format to \"word wrap\", and set the alignment to top/left."]
[]
[null,"Revision for 4/15/04 - this version has been changed to used the weighted average"]
[null,"percent air voids at production, versus the individual air voids"]
[]
[null,"Revision for 9/24/04 - this version is the first version to calculate the average"]
[null,"maximum specific gravitity for the day.  It also checks to see if there are more"]
[null,"than 2 max's for the day, and if there aren't, then it uses the moving average "]
[null,"of the max "]
[]
[null,"Revision for 7/21/05 - this version changes the dates to reflect specification "]
[null,"year 2005.  There are no functional changes to the spread sheet."]
[]
[null,"Revision for 8/11/05 - unprotected the workbook, multiple copies of the worksheet"]
[null,"can be made in one spread sheet"]

{"sheet":"INSTRUCTIONS OLD","index":4,"n_rows":42,"n_cols":2,"rows_kept":42,"hidden":true,"merged":[[3,0,3,9]],"flags":["formulas_cached_only"]}
[]
[]
[]
["IMPROVEMENTS TO THE INCENTIVE / DISINCENTIVE PROGRAM"]
[]
[null,"THIS PROGRAM HAS BEEN MODIFIED TO ALLOW WORKSHEETS"]
[null,"TO BE COPIED WITHIN THE WORKBOOK,  THEREFORE ONE"]
[null,"WORKBOOK (OR FILE) CAN CONTAIN SEVERAL DAYS OF PAVING."]
[]
[]
[null,"METHOD  1"]
[null,"CLICK TO THE WORKSHEET YOU WOULD LIKE TO COPY, MOVE"]
[null,"THE CURSOR DOWN TO THE TAB AT THE BOTTOM OF THE SHEET,"]
[null,"THE CURSOR WILL CHANGE TO AN ARROW TYPE FORM, THE  "]
[null,"HOLD THE CTRL (CONTROL) DOWN AND THEN LEFT CLICK AND "]
[null,"DOWN AND DRAG TO THE RIGHT."]
[]
[]
[null,"METHOD  2"]
[null,"CLICK TO THE WORKSHEET YOU WOULD LIKE TO COPY, MOVE"]
[null,"THE CURSOR DOWN TO THE TAB AT THE BOTTOM OF THE SHEET,"]
[null,"THE CURSOR WILL CHANGE TO AN ARROW TYPE FORM, THEN  "]
[null,"RIGHT CLICK, CLICK ON THE COPY/MOVE BUTTON, CLICK OR CHECK"]
[null,"THE CREATE A COPY BOX AND THEN CLICK ON OK."]
[]
[]
[null,"RENAME A WORKSHEET"]
[null,"CLICK TO THE WORKSHEET YOU WOULD LIKE TO RENAME, MOVE"]
[null,"THE CURSOR DOWN TO THE TAB AT THE BOTTOM OF THE SHEET,"]
[null,"THE CURSOR WILL CHANGE TO AN ARROW TYPE FORM, THEN  "]
[null,"RIGHT CLICK, CLICK ON THE RENAME BUTTON, THEN TYPE IN THE"]
[null,"NEW WORKSHEET NAME, ( some typing characters may not be allowed in a "]
[null,"name due to their formula type functions).   THEN PRESS ENTER."]
[]
[]
[null,"MOVING A WORKSHEET WITHIN A WORKBOOK."]
[null,"CLICK TO THE WORKSHEET YOU WOULD LIKE TO RENAME, MOVE"]
[null,"THE CURSOR DOWN TO THE TAB AT THE BOTTOM OF THE SHEET,"]
[null,"THE CURSOR WILL CHANGE TO AN ARROW TYPE FORM, THEN  "]
[null,"LEFT CLICK AND HOLD DOWN, WITH THE BOTTON DOWN YOU CAN "]
[null,"MOVE THE CURSOR TO THE RIGHT OR LEFT TO POSITION THE "]
[null,"WORKSHEET TO THE NEEDED POSITION."]